﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Citi.PTSConsolidation.Domain.Utils;
using System.Data;

namespace Citi.PTSConsolidation.Domain
{
    public partial class EntrepotBookOfWork
    {
        public decimal LastFullYear { get; set; }
        private static string ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["PTSDatabase"].ConnectionString;

        //public DataTable GetByGocs()
        //{
        //    //var query = string.Format("SELECT * FROM {0} WHERE {1} in ({2}) or {3} in ({4})", DatabaseNames.PTS.TableName, DatabaseNames.PTS.SystemGocCode, gocList, DatabaseNames.PTS.ClientGocCode, gocList);
        //    var query = string.Format("SELECT * FROM {0} WHERE {1} = 'LAD' or {2} = 'LAD'", DatabaseNames.PTS.TableName, DatabaseNames.PTS.SystemRegion, DatabaseNames.PTS.ClientRegion);

        //    return SqlHelper.ExecuteReader(query, ConnectionString);

        //}

        //public DataTable GetByRegion()
        //{
        //    var query = string.Format("SELECT * FROM {0} WHERE {1} = 'LAD' or {2} = 'LAD'", DatabaseNames.PTS.TableName, DatabaseNames.PTS.SystemRegion, DatabaseNames.PTS.ClientRegion);

        //    return SqlHelper.ExecuteReader(query, ConnectionString);
        //}

        //public DataTable GetAllGocs(string tableName)
        //{
        //    var query = string.Format("SELECT * FROM {0}", DatabaseNames.PTS.TableName);

        //    return SqlHelper.ExecuteReader(query, ConnectionString);
        //}

    }
}
